package com.anolesoft.amljmes.billing.service.mapper;

import cn.hutool.core.util.StrUtil;
import com.anolesoft.amljmes.billing.controller.CategoryInfoController;
import com.anolesoft.amljmes.billing.dto.CategoryInfoDto;
import com.anolesoft.amljmes.billing.dto.StfDeptDto;
import org.apache.ibatis.annotations.*;
import org.apache.ibatis.jdbc.SQL;

import java.util.List;

@Mapper
public interface StfDeptServiceMapper {
    @Select("select * from stf_dept where factory_id='16' and delete_flag=0 and dept_name in('16厂工段','16厂调度室')")
    List<StfDeptDto> departmentAll();

    @Select("select * from stf_dept where factory_id=#{factory_id} and delete_flag=0")
    List<StfDeptDto> queryDepartmentByFactory(@Param("factory_id") String factory);

}
